Profiling Report

Dataset statistics

Number of variables	10
Number of observations	132860
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	24.2 MiB
Average record size in memory	191.0 B

Variable types

DateTime	1
Numeric	8
Text	1

Alerts

`tavg` is highly overall correlated with `tmax` and 1 other fields	High correlation
`tmax` is highly overall correlated with `tavg` and 1 other fields	High correlation
`tmin` is highly overall correlated with `tavg` and 1 other fields	High correlation
`tmin` has 2299 (1.7%) zeros	Zeros
`prcp` has 87434 (65.8%) zeros	Zeros
`snow` has 128348 (96.6%) zeros	Zeros

Reproduction

Analysis started	2024-06-17 11:54:04.063209
Analysis finished	2024-06-17 11:54:08.827965
Duration	4.76 seconds
Software version	ydata-profiling v4.8.3
Download configuration	config.json

time
Date

Distinct	365
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

Minimum	2023-01-01 00:00:00
Maximum	2023-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

tavg
Real number (ℝ)

HIGH CORRELATION

Distinct	798
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.042641

Minimum	-39.1
Maximum	42.2
Zeros	208
Zeros (%)	0.2%
Negative	13875
Negative (%)	10.4%
Memory size	1.0 MiB

Quantile statistics

Minimum	-39.1
5-th percentile	-4.1
Q1	6.3
median	15.4
Q3	22.5
95-th percentile	28.9
Maximum	42.2
Range	81.3
Interquartile range (IQR)	16.2

Descriptive statistics

Standard deviation	10.672859
Coefficient of variation (CV)	0.76003217
Kurtosis	-0.073791662
Mean	14.042641
Median Absolute Deviation (MAD)	7.9
Skewness	-0.51108309
Sum	1865705.3
Variance	113.90992
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.9	565	0.4%
22.3	557	0.4%
23.1	556	0.4%
21.8	548	0.4%
22.6	544	0.4%
22.8	542	0.4%
20.6	542	0.4%
24.2	538	0.4%
20.3	537	0.4%
21.4	536	0.4%
Other values (788)	127395	95.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-39.1	1	< 0.1%
-36.7	1	< 0.1%
-36.4	1	< 0.1%
-36	1	< 0.1%
-35.6	1	< 0.1%
-35.2	2	< 0.1%
-35	1	< 0.1%
-34.8	1	< 0.1%
-34.6	1	< 0.1%
-34.3	1	< 0.1%

Value	Count	Frequency (%)
42.2	4	< 0.1%
41.3	2	< 0.1%
41.1	2	< 0.1%
40.9	2	< 0.1%
40.7	2	< 0.1%
40.6	2	< 0.1%
40.4	4	< 0.1%
40.3	9	< 0.1%
40.2	7	< 0.1%
39.9	4	< 0.1%

tmin
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	674
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.6998325

Minimum	-76
Maximum	37.2
Zeros	2299
Zeros (%)	1.7%
Negative	27827
Negative (%)	20.9%
Memory size	1.0 MiB

Quantile statistics

Minimum	-76
5-th percentile	-9.105
Q1	1.1
median	9.4
Q3	17.2
95-th percentile	24.4
Maximum	37.2
Range	113.2
Interquartile range (IQR)	16.1

Descriptive statistics

Standard deviation	10.680441
Coefficient of variation (CV)	1.2276606
Kurtosis	0.041017651
Mean	8.6998325
Median Absolute Deviation (MAD)	7.8
Skewness	-0.45497794
Sum	1155859.8
Variance	114.07183
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	2700	2.0%
11.7	2392	1.8%
15	2376	1.8%
0	2299	1.7%
13.9	2286	1.7%
12.2	2277	1.7%
14.4	2204	1.7%
13.3	2191	1.6%
10.6	2191	1.6%
8.3	2162	1.6%
Other values (664)	109782	82.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-76	1	< 0.1%
-41.1	1	< 0.1%
-40.6	1	< 0.1%
-40	2	< 0.1%
-39	4	< 0.1%
-38.9	1	< 0.1%
-38.8	1	< 0.1%
-38.3	1	< 0.1%
-38.2	1	< 0.1%
-38	2	< 0.1%

Value	Count	Frequency (%)
37.2	1	< 0.1%
36.1	2	< 0.1%
35.6	2	< 0.1%
35	6	< 0.1%
34.4	8	< 0.1%
33.9	20	< 0.1%
33.3	13	< 0.1%
33	1	< 0.1%
32.9	1	< 0.1%
32.8	18	< 0.1%

tmax
Real number (ℝ)

HIGH CORRELATION

Distinct	675
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.617149

Minimum	-35
Maximum	50
Zeros	827
Zeros (%)	0.6%
Negative	6290
Negative (%)	4.7%
Memory size	1.0 MiB

Quantile statistics

Minimum	-35
5-th percentile	0
Q1	11.7
median	21.2
Q3	28.9
95-th percentile	35
Maximum	50
Range	85
Interquartile range (IQR)	17.2

Descriptive statistics

Standard deviation	11.392223
Coefficient of variation (CV)	0.58072775
Kurtosis	-0.191582
Mean	19.617149
Median Absolute Deviation (MAD)	8.2
Skewness	-0.52030681
Sum	2606334.5
Variance	129.78275
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	2943	2.2%
28.3	2760	2.1%
29.4	2656	2.0%
27.8	2639	2.0%
28.9	2638	2.0%
27.2	2616	2.0%
25	2522	1.9%
30.6	2439	1.8%
26.7	2429	1.8%
26.1	2390	1.8%
Other values (665)	106828	80.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-35	1	< 0.1%
-33.3	2	< 0.1%
-32.8	1	< 0.1%
-32	1	< 0.1%
-31.7	1	< 0.1%
-31.1	2	< 0.1%
-30	4	< 0.1%
-29.4	1	< 0.1%
-29	1	< 0.1%
-28.9	2	< 0.1%

Value	Count	Frequency (%)
50	1	< 0.1%
48.9	1	< 0.1%
48.3	6	< 0.1%
48	1	< 0.1%
47.8	12	< 0.1%
47.2	5	< 0.1%
47	1	< 0.1%
46.7	21	< 0.1%
46.1	23	< 0.1%
46	2	< 0.1%

prcp
Real number (ℝ)

ZEROS

Distinct	812
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5206044

Minimum	0
Maximum	571.5
Zeros	87434
Zeros (%)	65.8%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	14.7
Maximum	571.5
Range	571.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.9157547
Coefficient of variation (CV)	3.1404193
Kurtosis	298.08058
Mean	2.5206044
Median Absolute Deviation (MAD)	0
Skewness	9.616785
Sum	334887.5
Variance	62.659172
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	87434	65.8%
0.3	3962	3.0%
0.5	2477	1.9%
0.8	1864	1.4%
1	1456	1.1%
1.3	1242	0.9%
1.5	1048	0.8%
1.8	1015	0.8%
0.2	898	0.7%
2	802	0.6%
Other values (802)	30662	23.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	87434	65.8%
0.1	792	0.6%
0.15	2	< 0.1%
0.2	898	0.7%
0.25	1	< 0.1%
0.3	3962	3.0%
0.35	1	< 0.1%
0.4	566	0.4%
0.45	2	< 0.1%
0.5	2477	1.9%

Value	Count	Frequency (%)
571.5	1	< 0.1%
316.7	1	< 0.1%
282.7	1	< 0.1%
242.1	1	< 0.1%
225	1	< 0.1%
204.5	1	< 0.1%
191.3	1	< 0.1%
177.8	1	< 0.1%
176.5	1	< 0.1%
169.9	3	< 0.1%

snow
Real number (ℝ)

ZEROS

Distinct	89
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.810131

Minimum	0
Maximum	1780
Zeros	128348
Zeros (%)	96.6%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1780
Range	1780
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	50.935283
Coefficient of variation (CV)	7.4793397
Kurtosis	146.63919
Mean	6.810131
Median Absolute Deviation (MAD)	0
Skewness	10.646904
Sum	904794
Variance	2594.4031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	128348	96.6%
30	800	0.6%
50	483	0.4%
80	337	0.3%
100	302	0.2%
130	259	0.2%
180	181	0.1%
150	179	0.1%
300	144	0.1%
250	136	0.1%
Other values (79)	1691	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	128348	96.6%
10	7	< 0.1%
20	7	< 0.1%
25	49	< 0.1%
30	800	0.6%
40	4	< 0.1%
50	483	0.4%
51	28	< 0.1%
60	2	< 0.1%
70	2	< 0.1%

Value	Count	Frequency (%)
1780	1	< 0.1%
1520	5	< 0.1%
1270	1	< 0.1%
940	2	< 0.1%
910	2	< 0.1%
890	8	< 0.1%
860	6	< 0.1%
840	14	< 0.1%
810	14	< 0.1%
790	10	< 0.1%

wdir
Real number (ℝ)

Distinct	507
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	188.68604

Minimum	0
Maximum	360
Zeros	598
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	11
Q1	79
median	197
Q3	297
95-th percentile	349
Maximum	360
Range	360
Interquartile range (IQR)	218

Descriptive statistics

Standard deviation	114.6291
Coefficient of variation (CV)	0.60751234
Kurtosis	-1.3637998
Mean	188.68604
Median Absolute Deviation (MAD)	108
Skewness	-0.13140983
Sum	25068828
Variance	13139.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
352	678	0.5%
342	627	0.5%
340	626	0.5%
346	623	0.5%
336	615	0.5%
355	614	0.5%
350	614	0.5%
2	613	0.5%
344	611	0.5%
345	611	0.5%
Other values (497)	126628	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	598	0.5%
1	591	0.4%
2	613	0.5%
3	550	0.4%
4	571	0.4%
5	556	0.4%
6	552	0.4%
7	552	0.4%
8	537	0.4%
9	562	0.4%

Value	Count	Frequency (%)
360	44	< 0.1%
359	600	0.5%
358	576	0.4%
357	603	0.5%
356	581	0.4%
355	614	0.5%
354	557	0.4%
353	602	0.5%
352	678	0.5%
351	584	0.4%

wspd
Real number (ℝ)

Distinct	517
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.424556

Minimum	0
Maximum	78.3
Zeros	34
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	4.3
Q1	7.9
median	11.3
Q3	15.7
95-th percentile	24.1
Maximum	78.3
Range	78.3
Interquartile range (IQR)	7.8

Descriptive statistics

Standard deviation	6.2112607
Coefficient of variation (CV)	0.49991812
Kurtosis	1.9571992
Mean	12.424556
Median Absolute Deviation (MAD)	3.7
Skewness	1.0698663
Sum	1650726.5
Variance	38.579759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.4	3301	2.5%
10.8	2787	2.1%
7.9	2632	2.0%
12.2	2532	1.9%
11.2	2362	1.8%
13.7	2189	1.6%
7.6	2142	1.6%
10.1	2119	1.6%
8.6	2113	1.6%
9.7	2096	1.6%
Other values (507)	108587	81.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34	< 0.1%
0.2	11	< 0.1%
0.3	7	< 0.1%
0.4	35	< 0.1%
0.5	9	< 0.1%
0.6	4	< 0.1%
0.7	67	0.1%
0.8	13	< 0.1%
0.9	13	< 0.1%
1	13	< 0.1%

Value	Count	Frequency (%)
78.3	1	< 0.1%
66.6	1	< 0.1%
62.3	1	< 0.1%
60.8	1	< 0.1%
59.4	1	< 0.1%
59.3	1	< 0.1%
56.9	1	< 0.1%
56.2	1	< 0.1%
55.8	1	< 0.1%
55.4	2	< 0.1%

pres
Real number (ℝ)

Distinct	773
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1015.6504

Minimum	964.3
Maximum	1051
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	964.3
5-th percentile	1005
Q1	1011.6
median	1015.4
Q3	1019.7
95-th percentile	1027.4
Maximum	1051
Range	86.7
Interquartile range (IQR)	8.1

Descriptive statistics

Standard deviation	6.9445985
Coefficient of variation (CV)	0.0068375878
Kurtosis	1.6793718
Mean	1015.6504
Median Absolute Deviation (MAD)	4.1
Skewness	-0.18209675
Sum	1.3493931 × 10⁸
Variance	48.227449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1014.4	992	0.7%
1014.9	978	0.7%
1013.9	972	0.7%
1015.5	958	0.7%
1014.2	957	0.7%
1013.8	944	0.7%
1013.4	943	0.7%
1015.3	941	0.7%
1014.5	935	0.7%
1015.8	929	0.7%
Other values (763)	123311	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
964.3	1	< 0.1%
964.7	1	< 0.1%
967.7	1	< 0.1%
968.6	1	< 0.1%
969.8	1	< 0.1%
970.1	1	< 0.1%
971	1	< 0.1%
971.2	1	< 0.1%
971.5	1	< 0.1%
971.7	1	< 0.1%

Value	Count	Frequency (%)
1051	1	< 0.1%
1049.2	1	< 0.1%
1047.2	1	< 0.1%
1047.1	1	< 0.1%
1046.9	1	< 0.1%
1046.1	2	< 0.1%
1045.8	1	< 0.1%
1045.7	1	< 0.1%
1045.3	1	< 0.1%
1044.6	1	< 0.1%

airport_id
Text

Distinct	364
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	398580
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ABE
2nd row	ABE
3rd row	ABE
4th row	ABE
5th row	ABE

Value	Count	Frequency (%)
abe	365	0.3%
atl	365	0.3%
abr	365	0.3%
aby	365	0.3%
ack	365	0.3%
act	365	0.3%
acv	365	0.3%
acy	365	0.3%
adk	365	0.3%
adq	365	0.3%
Other values (354)	129210	97.3%

Most occurring characters

Value	Count	Frequency (%)
S	32485	8.2%
A	30660	7.7%
C	24455	6.1%
L	24090	6.0%
T	22630	5.7%
B	21900	5.5%
M	21535	5.4%
R	19345	4.9%
P	18250	4.6%
I	17885	4.5%
Other values (16)	165345	41.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	398580	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
S	32485	8.2%
A	30660	7.7%
C	24455	6.1%
L	24090	6.0%
T	22630	5.7%
B	21900	5.5%
M	21535	5.4%
R	19345	4.9%
P	18250	4.6%
I	17885	4.5%
Other values (16)	165345	41.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	398580	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
S	32485	8.2%
A	30660	7.7%
C	24455	6.1%
L	24090	6.0%
T	22630	5.7%
B	21900	5.5%
M	21535	5.4%
R	19345	4.9%
P	18250	4.6%
I	17885	4.5%
Other values (16)	165345	41.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	398580	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
S	32485	8.2%
A	30660	7.7%
C	24455	6.1%
L	24090	6.0%
T	22630	5.7%
B	21900	5.5%
M	21535	5.4%
R	19345	4.9%
P	18250	4.6%
I	17885	4.5%
Other values (16)	165345	41.5%

Auto

Heatmap
Table

	prcp	pres	snow	tavg	tmax	tmin	wdir	wspd
prcp	1.000	-0.260	0.018	-0.021	-0.113	0.070	-0.086	0.139
pres	-0.260	1.000	0.025	-0.269	-0.237	-0.276	-0.056	-0.224
snow	0.018	0.025	1.000	-0.276	-0.275	-0.268	0.021	0.039
tavg	-0.021	-0.269	-0.276	1.000	0.970	0.969	-0.104	-0.048
tmax	-0.113	-0.237	-0.275	0.970	1.000	0.899	-0.086	-0.099
tmin	0.070	-0.276	-0.268	0.969	0.899	1.000	-0.123	-0.020
wdir	-0.086	-0.056	0.021	-0.104	-0.086	-0.123	1.000	0.004
wspd	0.139	-0.224	0.039	-0.048	-0.099	-0.020	0.004	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	time	tavg	tmin	tmax	prcp	wdir	wspd	pres	airport_id
0	2023-01-01	8.1	2.2	11.7	0.0	278.0	9.7	1013.8	ABE
1	2023-01-02	5.4	0.0	11.7	0.0	353.0	3.6	1019.6	ABE
2	2023-01-03	8.4	7.2	9.4	15.2	50.0	5.0	1013.9	ABE
3	2023-01-04	11.1	6.7	17.2	0.0	302.0	4.7	1009.8	ABE
4	2023-01-05	12.7	6.7	14.4	7.9	292.0	7.2	1013.0	ABE
5	2023-01-06	5.8	2.8	7.2	5.8	308.0	9.0	1016.6	ABE
6	2023-01-07	3.8	1.7	6.7	0.0	285.0	11.2	1022.2	ABE
7	2023-01-08	2.2	-2.7	3.9	0.0	346.0	6.8	1024.5	ABE
8	2023-01-09	2.3	-1.0	5.0	0.0	271.0	11.9	1015.2	ABE
9	2023-01-10	1.9	-1.6	4.4	0.0	250.0	9.4	1017.4	ABE

	time	tavg	tmin	tmax	prcp	wdir	wspd	pres	airport_id
132850	2023-12-22	14.4	12.0	16.1	8.6	53.0	13.9	1012.8	YUM
132851	2023-12-23	13.8	9.0	18.3	1.2	49.0	4.2	1014.9	YUM
132852	2023-12-24	14.0	10.0	18.9	0.0	16.0	7.5	1019.4	YUM
132853	2023-12-25	13.1	8.4	18.3	0.0	0.0	9.4	1020.5	YUM
132854	2023-12-26	12.8	8.0	19.4	0.0	11.0	8.4	1020.3	YUM
132855	2023-12-27	12.2	6.7	17.6	0.0	30.0	9.6	1021.0	YUM
132856	2023-12-28	12.8	6.7	21.0	0.0	12.0	11.1	1020.6	YUM
132857	2023-12-29	13.6	7.0	20.2	0.0	22.0	13.7	1020.0	YUM
132858	2023-12-30	13.6	7.0	21.0	0.0	337.0	11.2	1016.5	YUM
132859	2023-12-31	12.8	8.0	19.0	0.0	33.0	9.5	1019.0	YUM

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample